<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="inc/connmysql.jsp"%>
<html>

<head><style>
body{background:url(2.jpg) top left;
background-size:100%;}
</style></head>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>学生信息编辑页面</title>
<link rel="stylesheet" type="text/css" href="css/inputstyle.css" />
<style type="text/css">
<!--
.STYLE3 {
	font-family: "微软雅黑";
	color: #FF9900;
}
-->
</style>
</head>

<style type="text/css">
table.hovertable {
    font-family: verdana,arial,sans-serif;
    font-size:11px;
    color:#333333;
    border-width: 1px;
    border-color: #999999;
    border-collapse: collapse;
}
table.hovertable th {
    background-color:#c3dde0;
    border-width: 1px;
    padding: 8px;
    border-style: solid;
    border-color: #a9c6c9;
}
table.hovertable tr {
    background-color:#d4e3e5;
}
table.hovertable td {
    border-width: 1px;
    padding: 8px;
    border-style: solid;
    border-color: #a9c6c9;
}
.STYLE2 {font-size: 14pt}
.STYLE7 {font-size: 18px; font-family: "微软雅黑"; font-weight: bold; }
</style>


<%
String number=request.getParameter("number");
ResultSet rs=stmt.executeQuery("SELECT * FROM information WHERE number='"+number+"'");
String name="";
String subject="";
String score="";
if(rs.next()){
	name=rs.getString("name");
	subject=rs.getString("subject");
	number=rs.getString("number");
	score=rs.getString("score");
}

%>
<body>
<form name="myForm" method="post" action="edit_save.jsp">
  <table align="center" valign="middle" class="hovertable" width="21%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td height="32"><div align="center" class="tableTitle STYLE2 STYLE3">学生信息编辑页面</div></td>
    </tr>    
    <tr>
      <td><table width="98%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="29%" height="26"><div align="center" class="STYLE7">姓名：</div></td>
          <td width="71%"><input name="name" type="text" id="name" value="<%=name%>" height="25"></td>
        </tr>
        <tr>
          <td height="23"><div align="center" class="STYLE7">学号：</div></td>
          <td><input name="number" type="text" id="number" value="<%=number%>" height="25"></td>
        </tr>
        <tr>
          <td height="24"><div align="center" class="STYLE7">课程：</div></td>
          <td><input name="subject" type="text" id="subject" value="<%=subject%>" height="25"></td>
        </tr>
        <tr>
          <td height="24"><div align="center" class="STYLE7">成绩：</div></td>
          <td><input name="score" type="text" id="score" value="<%=score%>" height="25"></td>
        </tr>
      </table></td>
    </tr>
	<tr>
		<td height="39"><div align="center">
		  <input name="cmdSave" type="submit" class="bgclass2" id="cmdSave" value="保存"/>
		  <input name="cmdCancel" type="button" class="bgclass" id="cmdCancel" onClick="javascript:window.location='main.jsp';" value="取消"/>
	  </div></td>
	</tr>
  </table>
</form>
</body>
</html>
<%@ include file="inc/connmysql_close.jsp"%>